jdk1.4.2+tomcat5.0.28+jdbc3.0(jtds1.2)  jdk1.5+tomcat5.5.7+jdbc3.0(jtds)

1.½ϵͳtomcat_homeֵΪd:\Tomcat (tomcat5.0.28װ·)

2.½ϵͳjava_homeֵΪd:\jdk (jdkװ·)

3.޸path

  ڱֵ;d:\jdk\bin

4.½ϵͳclasspath

  ֵд;d:\jdk\lib\tools.jar;;d:\jdk\lib\dt.jar;%catalina_home%\common\lib\servlet.jar

5.startup.bat

  DOStomcat\bin\startup.bat

6.Եַhttp://localhost:8080

7.װJDBC(ms jdbcֶ֧βѯjtds)װ£

  a.jtds-1.1.jard:\Tomcat\common\lib\jtds-1.1.jar
  b.classpath
  ;d:\jdk\lib\tools.jar;;d:\jdk\lib\dt.jar;%catalina_home%\common\lib\servlet.jar;d:\jdk\lib\msbase.jar;d:\jdk\lib\mssqlserver.jar;d:\jdk\lib\msutil.jar;d:\Tomcat\common\lib\jtds-1.1.jar;

8.TomcatĿ¼(tomcat)
  Tomcat/conf/server.xmlļ<Host></host>֮<Context path="/site" docBase="d:\site" reloadable="true" debug="0"></Context>
  pathֵĿ¼docbase̷ֵʼ ӲĿ¼ľ·%Tomcat_Home%·
  <Context path="/jspbbs" docBase="g:\ftbbsrar\jspftbbs1.0" reloadable="true" debug="0">
  </Context>

9.ļϴ(classpath)
  ;d:\Tomcat\common\lib\jspSmartUpload.jar

10.sqlserver2000ݿǷɹ

jtdsӲļdb.jsp
<%@ page contentType="text/html;charset=gb2312"%> 
<%@ page import="java.sql.*"%> 
<html> 
<body> 
<%
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 
//String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=bbs"; 
//pubsΪݿ 
//String user="sa"; 
//String password=""; 
//Connection conn= DriverManager.getConnection(url,user,password); 
//Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 

Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance(); 
String url="jdbc:jtds:sqlserver://localhost:1433/bbs;USER=sa;PASSWORD="; 

Connection conn= DriverManager.getConnection(url); 
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

String sql="select * from bbstitle"; 
ResultSet rs=stmt.executeQuery(sql); 
while(rs.next()) {%> 
ĵһֶΪ<%=rs.getString(1)%> 
ĵڶֶΪ<%=rs.getString(2)%> 
<%}%> 
<%out.print("ݿɹϲ");%> 
<%
rs.close(); 
stmt.close(); 
conn.close(); 
%> 
</body> 
</html>

++++++++++++++++++Ȩ+++++++++++++++++++++++++++++++++++++++                                                       
+ Ϊ(shareware)ṩվʹá                 +
+ ǾȨɣý֮ӯӯԵҵ;      +
+ ΪӦʵʵļӦû߸Ľ书ܡܣԽбҪ޸+ 
+ ȥߵİȨʾý޸ĺ汾κεҵΪ    +
+ ΪûѡǷʹãʹгκ+
+ ʧ߲κΡ                                          +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++